# coding: utf-8
from . import db, BaseModel


class InboundOrders(db.Model):
    __tablename__ = 'inbound_orders'

    order_id = db.Column(db.Integer, primary_key=True)
    warehouse_id = db.Column(db.Integer, nullable=False)
    order_date = db.Column(db.DateTime, nullable=False)
    total_amount = db.Column(db.Numeric(10, 2))
    status = db.Column(db.String(50), nullable=False)
    created_at = db.Column(db.DateTime, server_default=db.FetchedValue())
    updated_at = db.Column(db.DateTime, server_default=db.FetchedValue())
